Hi there,
In this guide, I will walk you through the process of creating a single database in Azure SQL Database. Once created, you can query the database using the Query Editor in the Azure portal.
Prerequisites
To complete this task, you must have an active Azure subscription. If you do not have one yet, you can create a free account by following this link: Azure Free Account
Creating a Single Azure SQL Database
Step 1: Access Azure SQL Databases
- Go to the Microsoft Azure Portal. https://portal.azure.com/?quickstart=true#home
- On the homepage, click on the SQL Databases icon.
Step 2: Create a New SQL Database
- On the SQL Databases page, click Create SQL Database.
Step 3: Configure Database Settings
Basics Tab:
- Select the desired Azure Subscription.
- For the Resource group, click Create new, enter a name, and click OK.
- Enter the Database name (requirements: maximum 128 characters, no reserved words, and no existing database with the same name on the server).
- For Server, select Create new and proceed as follows: o Enter a Server name (Azure will notify you if the name is available). o Select the Location from the dropdown list. o For Authentication method, choose SQL Authentication. Create a Server Admin Login. Set a password. Click OK.
Workload Environment
- Under Workload environment, select either Development or Production. Note that the fees differ significantly between these options.
- Click Next to proceed to the Networking tab.
Networking Tab
- Choose the connectivity method (e.g., Public endpoint).
- Under Firewall rules, enable: o Allow Azure services and resources to access this server. o Add current client IP address.
Additional Settings Tab
- In the Data source section, select Sample.
- Click OK.
Step 4: Review and Create
- Review all information in the Tags and Review + create tabs.
- Click Create to finalize the database creation.
You have successfully created a sample Azure SQL Database. You can now query and manage your database directly from the Azure portal